"; }
} // end artista
if($artistb != 0){
$sql = "SELECT * FROM `allposters` WHERE MATCH ( Title ) AGAINST ( '$artistb' ) ORDER BY `rank` LIMIT 2";
$result = mysql_query($sql);
if ($result) { print " "; }
while($myrow = mysql_fetch_array($result)) {
?>
"; }
} // end artistb
if($artistc != 0){
$sql = "SELECT * FROM `allposters` WHERE MATCH ( Title ) AGAINST ( '$artistc' ) ORDER BY `rank` LIMIT 2";
$result = mysql_query($sql);
if ($result) { print " "; }
while($myrow = mysql_fetch_array($result)) {
?>
"; }
} // end artistc
if(($artista != '')) {
?>
";
} else if($imgurl == "0") {
print "\n";
for ($i = 0; $i <= $size; $i++) {
$theday = mktime (0,0,0,date("m") ,date("d")+$i ,date("Y"));
$option=date("D M j, Y",$theday);
$value=date("m:d:Y",$theday);
$dow=date("D",$theday);
if ($dow=="Sun") {
echo " \n";
}
if ($value == $default) {
$selected="SELECTED";
} else {
$selected="";
}
if (($dow!="Sun" and $dow!="Sat") or !$skip) {
echo "$option \n";
}
}
echo " \n";
}
function StoreAlbumInfo($id,$link,$label,$rdate,$asin=0){
ConnectToDB();
$sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1";
$result = mysql_query($sql);
while($myrow = mysql_fetch_assoc($result)) {
if($myrow['album_link'] == "1"){
mysql_query("UPDATE `mt_album` SET `album_link` = \"" . $link . "\" WHERE `album_id` = '$id' LIMIT 1");
}
if($myrow['album_label'] == "1"){
mysql_query("UPDATE `mt_album` SET `album_label` = \"" . $label . "\" WHERE `album_id` = '$id' LIMIT 1");
}
if($myrow['album_date'] == "1"){
mysql_query("UPDATE `mt_album` SET `album_date` = \"" . $rdate . "\" WHERE `album_id` = '$id' LIMIT 1");
}
if($myrow['album_ASIN'] == "1"){
mysql_query("UPDATE `mt_album` SET `album_ASIN` = \"" . $asin . "\" WHERE `album_id` = '$id' LIMIT 1");
}
}
}
function StoreAlbumASIN($id,$asin){
ConnectToDB();
$sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1";
$result = mysql_fetch_array(mysql_query($sql));
if($result['album_ASIN'] == "1"){
mysql_query("UPDATE `mt_album` SET `album_ASIN` = \"" . $asin . "\" WHERE `album_id` = '$id' LIMIT 1");
}
}
function PrintAlbumLink($id,$link){
ConnectToDB();
$sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1";
$result = mysql_query($sql);
while($myrow = mysql_fetch_assoc($result)) {
if($myrow['album_link'] == "1"){
mysql_query("UPDATE `mt_album` SET `album_link` = \"" . $link . "\" WHERE `album_id` = '$id' LIMIT 1");
print $link;
} else {
print $myrow['album_link'];
}
}
}
function PrintAlbumLabel($id,$label){
ConnectToDB();
$sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1";
$result = mysql_query($sql);
while($myrow = mysql_fetch_assoc($result)) {
if($myrow['album_label'] == "1"){
mysql_query("UPDATE `mt_album` SET `album_label` = \"" . $label . "\" WHERE `album_id` = '$id' LIMIT 1");
print $label;
} else {
print $myrow['album_label'];
}
}
}
function PrintAlbumDate($id,$rdate){
ConnectToDB();
$sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1";
$result = mysql_query($sql);
while($myrow = mysql_fetch_assoc($result)) {
if($myrow['album_date'] == "1"){
mysql_query("UPDATE `mt_album` SET `album_date` = \"" . $rdate . "\" WHERE `album_id` = '$id' LIMIT 1");
print $rdate;
} else {
print $myrow['album_date'];
}
}
}
function PrintAuthor($authorname,$authornick){
$imgurl = "/images/staff/" . $authorname . "_60.jpg";
$serverimg = "/home/rockmusi/public_html" . $imgurl;
print "";
if(file_exists($serverimg)){
print " ";
$result = mysql_query("SELECT stafftitle FROM `mt_author` WHERE author_name = '$authorname'");
$row = mysql_fetch_row($result);
print "" . $row[0] . " ";
}
function PrintAuthorNameLink($id){
$result = mysql_query("SELECT entry_author_id FROM `mt_entry` WHERE entry_id = '$id'");
$rowa = mysql_fetch_row($result);
$result = mysql_query("SELECT author_id, author_name, author_nickname FROM `mt_author` WHERE author_id = '$rowa[0]'");
$row = mysql_fetch_row($result);
print "" . $row[2] . " ";
}
function array_sort($array, $key)
{
for ($i = 0; $i < sizeof($array); $i++) {
$sort_values[$i] = $array[$i][$key];
}
asort ($sort_values);
reset ($sort_values);
while (list ($arr_key, $arr_val) = each ($sort_values)) {
$sorted_arr[] = $array[$arr_key];
}
return $sorted_arr;
}
function array_rsort($array, $key)
{
for ($i = 0; $i < sizeof($array); $i++) {
$sort_values[$i] = $array[$i][$key];
}
rsort ($sort_values);
reset ($sort_values);
while (list ($arr_key, $arr_val) = each ($sort_values)) {
$sorted_arr[] = $array[$arr_key];
}
return $sorted_arr;
}
function HeadStuff($section,$title,$desc){
?>
<? if($title){ print $title . " / "; } ?> <? if($section) { print $section . " / "; } ?>Rock Music Review
=$today AND `date` <=$week ORDER BY `artist` ASC";
$result = mysql_query($sql);
while($darow = mysql_fetch_array($result)) {
$sql = "SELECT * FROM `tours_artists` WHERE `id` = " . $darow['id'] . "";
$resultb = mysql_query($sql);
while($therow = mysql_fetch_array($resultb)) {
if(!in_array($therow['artist'],$last)){
$last[] = $therow['artist'];
}
}
}
$sorted_arr = array_sort($last, 0);
foreach ($sorted_arr as $art) {
print "" . $art . " ";
}
//print_r($sorted_arr);
?>
=$today AND `date` <=$week ORDER BY `artist` ASC";
$result = mysql_query($sql);
while($darow = mysql_fetch_array($result)) {
$sql = "SELECT * FROM `tours` WHERE `id` = " . $darow['id'] . "";
$resultb = mysql_query($sql);
while($therow = mysql_fetch_array($resultb)) {
if(!in_array($therow['artist'],$last)){
$last[] = $therow['artist'];
}
}
}
$sorted_arr = array_sort($last, 0);
foreach ($sorted_arr as $art) {
print "" . $art . " ";
}
//print_r($sorted_arr);
?> =$today) && ($resulta['date'] <=$week)){
print "" . $theartist . " is currently on tour... ";
return;
} else if($resulta['date'] >=$today) {
print "" . $theartist . " tour dates... ";
return;
}
}
}
if (!function_exists('virtual')) {
function virtual($file){
include("/home/rockmusi/public_html/$file");
}
}
if (!function_exists('mb_strtolower')) {
function mb_strtolower($a){
return strtolower($a);
}
}
?>![](\"/images/content/none.")
";
} else {
if($url == "x"){
$url = $imgurl;
}
copy($url,$tempfile);
$img = imagecreatefromjpeg( $tempfile );
// Get image size and scale ratio
$width = imagesx($img);
$height = imagesy($img);
$scale = min($w/$width, $h/$height);
// If the image is larger than the max shrink it
if ($scale < 1) {
$new_width = floor($scale*$width);
$new_height = floor($scale*$height);
// Create a new temporary image
$tmp_img = imagecreatetruecolor($new_width, $new_height);
// Copy and resize old image into new image
imagecopyresampled($tmp_img, $img, 0, 0, 0, 0, $new_width, $new_height, $width, $height);
imagedestroy($img);
$img = $tmp_img;
// store image to server
if(!@imagejpeg($tmp_img,$filename,85)){
echo "error saving jpeg.";
exit;
}
// update database
$sql = "UPDATE `mt_" . $type . "` SET `" . $type . "_" . $w . "` = \"" . $fileurl . "\" WHERE `" . $type . "_id` = $id LIMIT 1";
$result = mysql_query($sql);
print "